Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$MUTEX_SLEEP

`V$MUTEX_SLEEP` shows the wait time, and the number of sleeps for each combination of mutex type and location.

Column | Datatype | Description
--- | --- | ---
`MUTEX_TYPE` | `VARCHAR2(32)` | Type of action/object the mutex protects
`LOCATION` | `VARCHAR2(40)` | The code location where the waiter slept for the mutex
`SLEEPS` | `NUMBER` | Number of sleeps for this `MUTEX_TYPE` and `LOCATION`
`WAIT_TIME` | `NUMBER` | Wait time in microseconds